package com.ruoyi.applet.mapper;

import com.ruoyi.applet.domain.AppletSelect;
import com.ruoyi.applet.domain.AppletSite;

import java.math.BigDecimal;
import java.util.List;

/**
 * appletSiteMapper接口
 *
 * @author PENGFEIDENG
 * @date 2022-05-30
 */
public interface AppletSiteMapper {
    /**
     * 查询appletSite
     *
     * @param siteId appletSite主键
     * @return appletSite
     */
    AppletSite selectAppletSiteBySiteId(Long siteId);

    AppletSite getUserSite(BigDecimal mileage);

    AppletSite getUserNextSite(BigDecimal mileage);

    /**
     * 查询appletSite列表
     *
     * @param appletSite appletSite
     * @return appletSite集合
     */
    List<AppletSite> selectAppletSiteList(AppletSite appletSite);

    /**
     * 新增appletSite
     *
     * @param appletSite appletSite
     * @return 结果
     */
    int insertAppletSite(AppletSite appletSite);

    /**
     * 修改appletSite
     *
     * @param appletSite appletSite
     * @return 结果
     */
    int updateAppletSite(AppletSite appletSite);

    /**
     * 删除appletSite
     *
     * @param siteId appletSite主键
     * @return 结果
     */
    int deleteAppletSiteBySiteId(Long siteId);

    /**
     * 批量删除appletSite
     *
     * @param siteIds 需要删除的数据主键集合
     * @return 结果
     */
    int deleteAppletSiteBySiteIds(Long[] siteIds);


    List<AppletSelect> getSiteSelectList();

    Integer countUserLockSiteNum(BigDecimal mileage);

    Integer getSiteNumber();
}
